OLAP in enterprise decision modelling
نویسندگان
چکیده
This paper describes the application of online analytical processing (OLAP) in the field of data mining. We discuss knowledge discovery in enterprise databases as well as data warehouses. We then present an enterprise decision modelling application. This internet application stores requests, mistakes and defects that are notified by customers for software modules. Data are retrieved from Oracle database by using Microsoft Excel. Excel’s interactive visual interface helps to build data cube and get graphics for executive managers. This OLAP application is applicable to any ecommerce or supply-chain applications which accumulate huge data sets in order to have the potential to yield more valuable information.
منابع مشابه
An MDA approach for developing secure OLAP applications: Metamodels and transformations
Decision makers query enterprise information stored in DataWarehouses (DW) by using tools (such as On-Line Analytical Processing (OLAP) tools) which employ specific views or cubes from the corporate DW or Data Marts, based on multidimensional modelling. Since the information managed is critical, security constraints have to be correctly established in order to avoid unauthorized access. In prev...
متن کاملShowing the Benefits of Applying a Model Driven Architecture for Developing Secure OLAP Applications
Data Warehouses (DW) manage enterprise information that is queried for decision making purposes by using On-Line Analytical Processing (OLAP) tools. The establishment of security constraints in all development stages and operations of the DW is highly important since otherwise, unauthorized users may discover vital business information. The final users of OLAP tools access and analyze the infor...
متن کاملAn architecture for automatically developing secure OLAP applications from models
Decision makers query enterprise information stored in Data Warehouses (DW) by using tools (such as On-Line Analytical Processing (OLAP) tools) which use specific views or cubes from the corporate DW or Data Marts, based on the multidimensional modelling. Since the information managed is critical, security constraints have to be correctly established in order to avoid unauthorized accesses. In ...
متن کاملOptimization Research of the OLAP Query Technology Based on P2P
With the increasing data of the application system, the fast and efficient access to the information of support decision-making analysis has become more and more difficult. At the same time, analysis of the data is no longer on a single server or a single enterprise data, but on multiple servers, multiple departments or multiple enterprise data. So, the original OLAP technologies have also reve...
متن کاملUser-Centric Spatial DataWarehousing: A Survey of Requirements & Approaches
Data warehouses have traditionally been used to analyse large multidimensional datasets and provide enterprise decision support. With an increased availability of spatial data in recent years, several new strategies have been proposed to enable their integration into data warehouses and OLAP systems and perform complex analysis on them. One strategy to achieve this is to integrate existing Geog...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
عنوان ژورنال:
دوره شماره
صفحات -
تاریخ انتشار 2004